Postgres Technical Deep Dive

Reliable Distributed PostgreSQL (RDPG)

Description

This is Reliable Distributed PostgreSQL (RDPG) for Bosh release. This release is used for postgres development on Cloud Foundry.

Deployment Topology

VM Requirements VM Name VM Type Ephemeral Disk Size Persistent Disk Size rdpg/0 m3.large 32GB 64GB rdpg/0 m3.large 32GB 64GB rdpg/2 m3.large 32GB 64GB HA Components (Consul Architecture)

Multi AZ support: Supports 2 or more 2 HA zones. The current production(R4) deployment is defaulted at 2 HA zones Replication & Election: Consul servers perform leader election and replication. For changes to be processed, a minimum quorum of servers (N/2)+1 must be available. That means if there are 3 server nodes, at least 2 must be available. Scale Out Capabilities

Data partitioning, Replication: One of the key features of Consul is its support for multiple datacenters. The architecture of Consul is designed to promote a low coupling of datacenters so that connectivity issues or failure of any datacenter does not impact the availability of Consul in other datacenters. This means each datacenter runs independently, each having a dedicated group of servers and a private LAN gossip pool. Multi-tenant Capabilities Description: Consul architecture is described as a cluster of multi-tenant servers mirrored by HA zone.

Service Plan Overview

Service Plans - (TO BE COMPLETED)

Service Plan enforcement mechanisms - (TO BE COMPLETED)

Monitoring and Instrumentation

Health Checks - (TO BE COMPLETED)

Performance Counters - (TO BE COMPLETED)

Backup and Restore

For information on Backup and Restore policy, please visit: https://github.build.ge.com/industrial-cloud/Documentation/wiki/Predix-Services-Backup-and-Retention-Policy